CREATE TABLE [dbo].[PublishRequest]
(
[PublishRequestKey] [uniqueidentifier] NOT NULL,
[PublishPriorityCode] [int] NOT NULL,
[DocumentKey] [uniqueidentifier] NULL,
[RequestDateTime] [datetime] NOT NULL,
[UserKey] [uniqueidentifier] NOT NULL,
[PublishedDateTime] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[PublishRequest] ADD CONSTRAINT [PK_PublishRequest] PRIMARY KEY CLUSTERED ([PublishRequestKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PublishRequest_DocumentKey] ON [dbo].[PublishRequest] ([DocumentKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PublishRequest_PublishPriorityCode] ON [dbo].[PublishRequest] ([PublishPriorityCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PublishRequest_UserKey] ON [dbo].[PublishRequest] ([UserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PublishRequest] ADD CONSTRAINT [FK_PublishRequest_DocumentMain] FOREIGN KEY ([DocumentKey]) REFERENCES [dbo].[DocumentMain] ([DocumentKey]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[PublishRequest] ADD CONSTRAINT [FK_PublishRequest_PublishPriorityRef] FOREIGN KEY ([PublishPriorityCode]) REFERENCES [dbo].[PublishPriorityRef] ([PublishPriorityCode])
GO
ALTER TABLE [dbo].[PublishRequest] ADD CONSTRAINT [FK_PublishRequest_UserMain] FOREIGN KEY ([UserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO